<test>
  <sql>SELECT  *
FROM    Orders o
            INNER JOIN Customers c ON c.CustomerID = o.CustomerID
WHERE   ((SELECT e.City FROM Employees e WHERE e.EmployeeId = o.EmployeeId)) = c.City
</sql>
  <expectedResults>
    <NewDataSet>
  <xs:schema id="NewDataSet" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
      <xs:complexType>
        <xs:choice minOccurs="0" maxOccurs="unbounded">
          <xs:element name="Table1" msdata:Locale="en-US">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="OrderID" type="xs:int" minOccurs="0" />
                <xs:element name="CustomerID" type="xs:string" minOccurs="0" />
                <xs:element name="EmployeeID" type="xs:int" minOccurs="0" />
                <xs:element name="OrderDate" type="xs:dateTime" minOccurs="0" />
                <xs:element name="RequiredDate" type="xs:dateTime" minOccurs="0" />
                <xs:element name="ShippedDate" type="xs:dateTime" minOccurs="0" />
                <xs:element name="ShipVia" type="xs:int" minOccurs="0" />
                <xs:element name="Freight" type="xs:decimal" minOccurs="0" />
                <xs:element name="ShipName" type="xs:string" minOccurs="0" />
                <xs:element name="ShipAddress" type="xs:string" minOccurs="0" />
                <xs:element name="ShipCity" type="xs:string" minOccurs="0" />
                <xs:element name="ShipRegion" type="xs:string" minOccurs="0" />
                <xs:element name="ShipPostalCode" type="xs:string" minOccurs="0" />
                <xs:element name="ShipCountry" type="xs:string" minOccurs="0" />
                <xs:element name="CustomerID1" msdata:Caption="CustomerID" type="xs:string" minOccurs="0" />
                <xs:element name="CompanyName" type="xs:string" minOccurs="0" />
                <xs:element name="ContactName" type="xs:string" minOccurs="0" />
                <xs:element name="ContactTitle" type="xs:string" minOccurs="0" />
                <xs:element name="Address" type="xs:string" minOccurs="0" />
                <xs:element name="City" type="xs:string" minOccurs="0" />
                <xs:element name="Region" type="xs:string" minOccurs="0" />
                <xs:element name="PostalCode" type="xs:string" minOccurs="0" />
                <xs:element name="Country" type="xs:string" minOccurs="0" />
                <xs:element name="Phone" type="xs:string" minOccurs="0" />
                <xs:element name="Fax" type="xs:string" minOccurs="0" />
              </xs:sequence>
            </xs:complexType>
          </xs:element>
        </xs:choice>
      </xs:complexType>
    </xs:element>
  </xs:schema>
  <Table1>
    <OrderID>10289</OrderID>
    <CustomerID>BSBEV</CustomerID>
    <EmployeeID>7</EmployeeID>
    <OrderDate>1996-08-25T15:00:00-07:00</OrderDate>
    <RequiredDate>1996-09-22T15:00:00-07:00</RequiredDate>
    <ShippedDate>1996-08-27T15:00:00-07:00</ShippedDate>
    <ShipVia>3</ShipVia>
    <Freight>22.77</Freight>
    <ShipName>B's Beverages</ShipName>
    <ShipAddress>Fauntleroy Circus</ShipAddress>
    <ShipCity>London</ShipCity>
    <ShipPostalCode>EC2 5NT</ShipPostalCode>
    <ShipCountry>UK</ShipCountry>
    <CustomerID1>BSBEV</CustomerID1>
    <CompanyName>B's Beverages</CompanyName>
    <ContactName>Victoria Ashworth</ContactName>
    <ContactTitle>Sales Representative</ContactTitle>
    <Address>Fauntleroy Circus</Address>
    <City>London</City>
    <PostalCode>EC2 5NT</PostalCode>
    <Country>UK</Country>
    <Phone>(171) 555-1212</Phone>
  </Table1>
  <Table1>
    <OrderID>10355</OrderID>
    <CustomerID>AROUT</CustomerID>
    <EmployeeID>6</EmployeeID>
    <OrderDate>1996-11-14T15:00:00-08:00</OrderDate>
    <RequiredDate>1996-12-12T15:00:00-08:00</RequiredDate>
    <ShippedDate>1996-11-19T15:00:00-08:00</ShippedDate>
    <ShipVia>1</ShipVia>
    <Freight>41.95</Freight>
    <ShipName>Around the Horn</ShipName>
    <ShipAddress>Brook Farm Stratford St. Mary</ShipAddress>
    <ShipCity>Colchester</ShipCity>
    <ShipRegion>Essex</ShipRegion>
    <ShipPostalCode>CO7 6JX</ShipPostalCode>
    <ShipCountry>UK</ShipCountry>
    <CustomerID1>AROUT</CustomerID1>
    <CompanyName>Around the Horn</CompanyName>
    <ContactName>Thomas Hardy</ContactName>
    <ContactTitle>Sales Representative</ContactTitle>
    <Address>120 Hanover Sq.</Address>
    <City>London</City>
    <PostalCode>WA1 1DP</PostalCode>
    <Country>UK</Country>
    <Phone>(171) 555-7788</Phone>
    <Fax>(171) 555-6750</Fax>
  </Table1>
  <Table1>
    <OrderID>10359</OrderID>
    <CustomerID>SEVES</CustomerID>
    <EmployeeID>5</EmployeeID>
    <OrderDate>1996-11-20T15:00:00-08:00</OrderDate>
    <RequiredDate>1996-12-18T15:00:00-08:00</RequiredDate>
    <ShippedDate>1996-11-25T15:00:00-08:00</ShippedDate>
    <ShipVia>3</ShipVia>
    <Freight>288.43</Freight>
    <ShipName>Seven Seas Imports</ShipName>
    <ShipAddress>90 Wadhurst Rd.</ShipAddress>
    <ShipCity>London</ShipCity>
    <ShipPostalCode>OX15 4NB</ShipPostalCode>
    <ShipCountry>UK</ShipCountry>
    <CustomerID1>SEVES</CustomerID1>
    <CompanyName>Seven Seas Imports</CompanyName>
    <ContactName>Hari Kumar</ContactName>
    <ContactTitle>Sales Manager</ContactTitle>
    <Address>90 Wadhurst Rd.</Address>
    <City>London</City>
    <PostalCode>OX15 4NB</PostalCode>
    <Country>UK</Country>
    <Phone>(171) 555-1717</Phone>
    <Fax>(171) 555-5646</Fax>
  </Table1>
  <Table1>
    <OrderID>10469</OrderID>
    <CustomerID>WHITC</CustomerID>
    <EmployeeID>1</EmployeeID>
    <OrderDate>1997-03-09T15:00:00-08:00</OrderDate>
    <RequiredDate>1997-04-06T15:00:00-07:00</RequiredDate>
    <ShippedDate>1997-03-13T15:00:00-08:00</ShippedDate>
    <ShipVia>1</ShipVia>
    <Freight>60.18</Freight>
    <ShipName>White Clover Markets</ShipName>
    <ShipAddress>1029 - 12th Ave. S.</ShipAddress>
    <ShipCity>Seattle</ShipCity>
    <ShipRegion>WA</ShipRegion>
    <ShipPostalCode>98124</ShipPostalCode>
    <ShipCountry>USA</ShipCountry>
    <CustomerID1>WHITC</CustomerID1>
    <CompanyName>White Clover Markets</CompanyName>
    <ContactName>Karl Jablonski</ContactName>
    <ContactTitle>Owner</ContactTitle>
    <Address>305 - 14th Ave. S. Suite 3B</Address>
    <City>Seattle</City>
    <Region>WA</Region>
    <PostalCode>98128</PostalCode>
    <Country>USA</Country>
    <Phone>(206) 555-4112</Phone>
    <Fax>(206) 555-4115</Fax>
  </Table1>
  <Table1>
    <OrderID>10523</OrderID>
    <CustomerID>SEVES</CustomerID>
    <EmployeeID>7</EmployeeID>
    <OrderDate>1997-04-30T15:00:00-07:00</OrderDate>
    <RequiredDate>1997-05-28T15:00:00-07:00</RequiredDate>
    <ShippedDate>1997-05-29T15:00:00-07:00</ShippedDate>
    <ShipVia>2</ShipVia>
    <Freight>77.63</Freight>
    <ShipName>Seven Seas Imports</ShipName>
    <ShipAddress>90 Wadhurst Rd.</ShipAddress>
    <ShipCity>London</ShipCity>
    <ShipPostalCode>OX15 4NB</ShipPostalCode>
    <ShipCountry>UK</ShipCountry>
    <CustomerID1>SEVES</CustomerID1>
    <CompanyName>Seven Seas Imports</CompanyName>
    <ContactName>Hari Kumar</ContactName>
    <ContactTitle>Sales Manager</ContactTitle>
    <Address>90 Wadhurst Rd.</Address>
    <City>London</City>
    <PostalCode>OX15 4NB</PostalCode>
    <Country>UK</Country>
    <Phone>(171) 555-1717</Phone>
    <Fax>(171) 555-5646</Fax>
  </Table1>
  <Table1>
    <OrderID>10532</OrderID>
    <CustomerID>EASTC</CustomerID>
    <EmployeeID>7</EmployeeID>
    <OrderDate>1997-05-08T15:00:00-07:00</OrderDate>
    <RequiredDate>1997-06-05T15:00:00-07:00</RequiredDate>
    <ShippedDate>1997-05-11T15:00:00-07:00</ShippedDate>
    <ShipVia>3</ShipVia>
    <Freight>74.46</Freight>
    <ShipName>Eastern Connection</ShipName>
    <ShipAddress>35 King George</ShipAddress>
    <ShipCity>London</ShipCity>
    <ShipPostalCode>WX3 6FW</ShipPostalCode>
    <ShipCountry>UK</ShipCountry>
    <CustomerID1>EASTC</CustomerID1>
    <CompanyName>Eastern Connection</CompanyName>
    <ContactName>Ann Devon</ContactName>
    <ContactTitle>Sales Agent</ContactTitle>
    <Address>35 King George</Address>
    <City>London</City>
    <PostalCode>WX3 6FW</PostalCode>
    <Country>UK</Country>
    <Phone>(171) 555-0297</Phone>
    <Fax>(171) 555-3373</Fax>
  </Table1>
  <Table1>
    <OrderID>10538</OrderID>
    <CustomerID>BSBEV</CustomerID>
    <EmployeeID>9</EmployeeID>
    <OrderDate>1997-05-14T15:00:00-07:00</OrderDate>
    <RequiredDate>1997-06-11T15:00:00-07:00</RequiredDate>
    <ShippedDate>1997-05-15T15:00:00-07:00</ShippedDate>
    <ShipVia>3</ShipVia>
    <Freight>4.87</Freight>
    <ShipName>B's Beverages</ShipName>
    <ShipAddress>Fauntleroy Circus</ShipAddress>
    <ShipCity>London</ShipCity>
    <ShipPostalCode>EC2 5NT</ShipPostalCode>
    <ShipCountry>UK</ShipCountry>
    <CustomerID1>BSBEV</CustomerID1>
    <CompanyName>B's Beverages</CompanyName>
    <ContactName>Victoria Ashworth</ContactName>
    <ContactTitle>Sales Representative</ContactTitle>
    <Address>Fauntleroy Circus</Address>
    <City>London</City>
    <PostalCode>EC2 5NT</PostalCode>
    <Country>UK</Country>
    <Phone>(171) 555-1212</Phone>
  </Table1>
  <Table1>
    <OrderID>10539</OrderID>
    <CustomerID>BSBEV</CustomerID>
    <EmployeeID>6</EmployeeID>
    <OrderDate>1997-05-15T15:00:00-07:00</OrderDate>
    <RequiredDate>1997-06-12T15:00:00-07:00</RequiredDate>
    <ShippedDate>1997-05-22T15:00:00-07:00</ShippedDate>
    <ShipVia>3</ShipVia>
    <Freight>12.36</Freight>
    <ShipName>B's Beverages</ShipName>
    <ShipAddress>Fauntleroy Circus</ShipAddress>
    <ShipCity>London</ShipCity>
    <ShipPostalCode>EC2 5NT</ShipPostalCode>
    <ShipCountry>UK</ShipCountry>
    <CustomerID1>BSBEV</CustomerID1>
    <CompanyName>B's Beverages</CompanyName>
    <ContactName>Victoria Ashworth</ContactName>
    <ContactTitle>Sales Representative</ContactTitle>
    <Address>Fauntleroy Circus</Address>
    <City>London</City>
    <PostalCode>EC2 5NT</PostalCode>
    <Country>UK</Country>
    <Phone>(171) 555-1212</Phone>
  </Table1>
  <Table1>
    <OrderID>10596</OrderID>
    <CustomerID>WHITC</CustomerID>
    <EmployeeID>8</EmployeeID>
    <OrderDate>1997-07-10T15:00:00-07:00</OrderDate>
    <RequiredDate>1997-08-07T15:00:00-07:00</RequiredDate>
    <ShippedDate>1997-08-11T15:00:00-07:00</ShippedDate>
    <ShipVia>1</ShipVia>
    <Freight>16.34</Freight>
    <ShipName>White Clover Markets</ShipName>
    <ShipAddress>1029 - 12th Ave. S.</ShipAddress>
    <ShipCity>Seattle</ShipCity>
    <ShipRegion>WA</ShipRegion>
    <ShipPostalCode>98124</ShipPostalCode>
    <ShipCountry>USA</ShipCountry>
    <CustomerID1>WHITC</CustomerID1>
    <CompanyName>White Clover Markets</CompanyName>
    <ContactName>Karl Jablonski</ContactName>
    <ContactTitle>Owner</ContactTitle>
    <Address>305 - 14th Ave. S. Suite 3B</Address>
    <City>Seattle</City>
    <Region>WA</Region>
    <PostalCode>98128</PostalCode>
    <Country>USA</Country>
    <Phone>(206) 555-4112</Phone>
    <Fax>(206) 555-4115</Fax>
  </Table1>
  <Table1>
    <OrderID>10599</OrderID>
    <CustomerID>BSBEV</CustomerID>
    <EmployeeID>6</EmployeeID>
    <OrderDate>1997-07-14T15:00:00-07:00</OrderDate>
    <RequiredDate>1997-08-25T15:00:00-07:00</RequiredDate>
    <ShippedDate>1997-07-20T15:00:00-07:00</ShippedDate>
    <ShipVia>3</ShipVia>
    <Freight>29.98</Freight>
    <ShipName>B's Beverages</ShipName>
    <ShipAddress>Fauntleroy Circus</ShipAddress>
    <ShipCity>London</ShipCity>
    <ShipPostalCode>EC2 5NT</ShipPostalCode>
    <ShipCountry>UK</ShipCountry>
    <CustomerID1>BSBEV</CustomerID1>
    <CompanyName>B's Beverages</CompanyName>
    <ContactName>Victoria Ashworth</ContactName>
    <ContactTitle>Sales Representative</ContactTitle>
    <Address>Fauntleroy Circus</Address>
    <City>London</City>
    <PostalCode>EC2 5NT</PostalCode>
    <Country>UK</Country>
    <Phone>(171) 555-1212</Phone>
  </Table1>
  <Table1>
    <OrderID>10696</OrderID>
    <CustomerID>WHITC</CustomerID>
    <EmployeeID>8</EmployeeID>
    <OrderDate>1997-10-07T15:00:00-07:00</OrderDate>
    <RequiredDate>1997-11-18T15:00:00-08:00</RequiredDate>
    <ShippedDate>1997-10-13T15:00:00-07:00</ShippedDate>
    <ShipVia>3</ShipVia>
    <Freight>102.55</Freight>
    <ShipName>White Clover Markets</ShipName>
    <ShipAddress>1029 - 12th Ave. S.</ShipAddress>
    <ShipCity>Seattle</ShipCity>
    <ShipRegion>WA</ShipRegion>
    <ShipPostalCode>98124</ShipPostalCode>
    <ShipCountry>USA</ShipCountry>
    <CustomerID1>WHITC</CustomerID1>
    <CompanyName>White Clover Markets</CompanyName>
    <ContactName>Karl Jablonski</ContactName>
    <ContactTitle>Owner</ContactTitle>
    <Address>305 - 14th Ave. S. Suite 3B</Address>
    <City>Seattle</City>
    <Region>WA</Region>
    <PostalCode>98128</PostalCode>
    <Country>USA</Country>
    <Phone>(206) 555-4112</Phone>
    <Fax>(206) 555-4115</Fax>
  </Table1>
  <Table1>
    <OrderID>10804</OrderID>
    <CustomerID>SEVES</CustomerID>
    <EmployeeID>6</EmployeeID>
    <OrderDate>1997-12-29T15:00:00-08:00</OrderDate>
    <RequiredDate>1998-01-26T15:00:00-08:00</RequiredDate>
    <ShippedDate>1998-01-06T15:00:00-08:00</ShippedDate>
    <ShipVia>2</ShipVia>
    <Freight>27.33</Freight>
    <ShipName>Seven Seas Imports</ShipName>
    <ShipAddress>90 Wadhurst Rd.</ShipAddress>
    <ShipCity>London</ShipCity>
    <ShipPostalCode>OX15 4NB</ShipPostalCode>
    <ShipCountry>UK</ShipCountry>
    <CustomerID1>SEVES</CustomerID1>
    <CompanyName>Seven Seas Imports</CompanyName>
    <ContactName>Hari Kumar</ContactName>
    <ContactTitle>Sales Manager</ContactTitle>
    <Address>90 Wadhurst Rd.</Address>
    <City>London</City>
    <PostalCode>OX15 4NB</PostalCode>
    <Country>UK</Country>
    <Phone>(171) 555-1717</Phone>
    <Fax>(171) 555-5646</Fax>
  </Table1>
  <Table1>
    <OrderID>10848</OrderID>
    <CustomerID>CONSH</CustomerID>
    <EmployeeID>7</EmployeeID>
    <OrderDate>1998-01-22T15:00:00-08:00</OrderDate>
    <RequiredDate>1998-02-19T15:00:00-08:00</RequiredDate>
    <ShippedDate>1998-01-28T15:00:00-08:00</ShippedDate>
    <ShipVia>2</ShipVia>
    <Freight>38.24</Freight>
    <ShipName>Consolidated Holdings</ShipName>
    <ShipAddress>Berkeley Gardens 12  Brewery</ShipAddress>
    <ShipCity>London</ShipCity>
    <ShipPostalCode>WX1 6LT</ShipPostalCode>
    <ShipCountry>UK</ShipCountry>
    <CustomerID1>CONSH</CustomerID1>
    <CompanyName>Consolidated Holdings</CompanyName>
    <ContactName>Elizabeth Brown</ContactName>
    <ContactTitle>Sales Representative</ContactTitle>
    <Address>Berkeley Gardens 12  Brewery</Address>
    <City>London</City>
    <PostalCode>WX1 6LT</PostalCode>
    <Country>UK</Country>
    <Phone>(171) 555-2282</Phone>
    <Fax>(171) 555-9199</Fax>
  </Table1>
  <Table1>
    <OrderID>10869</OrderID>
    <CustomerID>SEVES</CustomerID>
    <EmployeeID>5</EmployeeID>
    <OrderDate>1998-02-03T15:00:00-08:00</OrderDate>
    <RequiredDate>1998-03-03T15:00:00-08:00</RequiredDate>
    <ShippedDate>1998-02-08T15:00:00-08:00</ShippedDate>
    <ShipVia>1</ShipVia>
    <Freight>143.28</Freight>
    <ShipName>Seven Seas Imports</ShipName>
    <ShipAddress>90 Wadhurst Rd.</ShipAddress>
    <ShipCity>London</ShipCity>
    <ShipPostalCode>OX15 4NB</ShipPostalCode>
    <ShipCountry>UK</ShipCountry>
    <CustomerID1>SEVES</CustomerID1>
    <CompanyName>Seven Seas Imports</CompanyName>
    <ContactName>Hari Kumar</ContactName>
    <ContactTitle>Sales Manager</ContactTitle>
    <Address>90 Wadhurst Rd.</Address>
    <City>London</City>
    <PostalCode>OX15 4NB</PostalCode>
    <Country>UK</Country>
    <Phone>(171) 555-1717</Phone>
    <Fax>(171) 555-5646</Fax>
  </Table1>
  <Table1>
    <OrderID>10953</OrderID>
    <CustomerID>AROUT</CustomerID>
    <EmployeeID>9</EmployeeID>
    <OrderDate>1998-03-15T15:00:00-08:00</OrderDate>
    <RequiredDate>1998-03-29T14:00:00-08:00</RequiredDate>
    <ShippedDate>1998-03-24T15:00:00-08:00</ShippedDate>
    <ShipVia>2</ShipVia>
    <Freight>23.72</Freight>
    <ShipName>Around the Horn</ShipName>
    <ShipAddress>Brook Farm Stratford St. Mary</ShipAddress>
    <ShipCity>Colchester</ShipCity>
    <ShipRegion>Essex</ShipRegion>
    <ShipPostalCode>CO7 6JX</ShipPostalCode>
    <ShipCountry>UK</ShipCountry>
    <CustomerID1>AROUT</CustomerID1>
    <CompanyName>Around the Horn</CompanyName>
    <ContactName>Thomas Hardy</ContactName>
    <ContactTitle>Sales Representative</ContactTitle>
    <Address>120 Hanover Sq.</Address>
    <City>London</City>
    <PostalCode>WA1 1DP</PostalCode>
    <Country>UK</Country>
    <Phone>(171) 555-7788</Phone>
    <Fax>(171) 555-6750</Fax>
  </Table1>
  <Table1>
    <OrderID>11016</OrderID>
    <CustomerID>AROUT</CustomerID>
    <EmployeeID>9</EmployeeID>
    <OrderDate>1998-04-09T15:00:00-07:00</OrderDate>
    <RequiredDate>1998-05-07T15:00:00-07:00</RequiredDate>
    <ShippedDate>1998-04-12T15:00:00-07:00</ShippedDate>
    <ShipVia>2</ShipVia>
    <Freight>33.8</Freight>
    <ShipName>Around the Horn</ShipName>
    <ShipAddress>Brook Farm Stratford St. Mary</ShipAddress>
    <ShipCity>Colchester</ShipCity>
    <ShipRegion>Essex</ShipRegion>
    <ShipPostalCode>CO7 6JX</ShipPostalCode>
    <ShipCountry>UK</ShipCountry>
    <CustomerID1>AROUT</CustomerID1>
    <CompanyName>Around the Horn</CompanyName>
    <ContactName>Thomas Hardy</ContactName>
    <ContactTitle>Sales Representative</ContactTitle>
    <Address>120 Hanover Sq.</Address>
    <City>London</City>
    <PostalCode>WA1 1DP</PostalCode>
    <Country>UK</Country>
    <Phone>(171) 555-7788</Phone>
    <Fax>(171) 555-6750</Fax>
  </Table1>
  <Table1>
    <OrderID>11047</OrderID>
    <CustomerID>EASTC</CustomerID>
    <EmployeeID>7</EmployeeID>
    <OrderDate>1998-04-23T15:00:00-07:00</OrderDate>
    <RequiredDate>1998-05-21T15:00:00-07:00</RequiredDate>
    <ShippedDate>1998-04-30T15:00:00-07:00</ShippedDate>
    <ShipVia>3</ShipVia>
    <Freight>46.62</Freight>
    <ShipName>Eastern Connection</ShipName>
    <ShipAddress>35 King George</ShipAddress>
    <ShipCity>London</ShipCity>
    <ShipPostalCode>WX3 6FW</ShipPostalCode>
    <ShipCountry>UK</ShipCountry>
    <CustomerID1>EASTC</CustomerID1>
    <CompanyName>Eastern Connection</CompanyName>
    <ContactName>Ann Devon</ContactName>
    <ContactTitle>Sales Agent</ContactTitle>
    <Address>35 King George</Address>
    <City>London</City>
    <PostalCode>WX3 6FW</PostalCode>
    <Country>UK</Country>
    <Phone>(171) 555-0297</Phone>
    <Fax>(171) 555-3373</Fax>
  </Table1>
</NewDataSet>
  </expectedResults>
  <expectedPlan>
    <executionPlan>
      <element operator="Select">
        <properties>
          <property name="Output List.[00]" value="o.OrderID AS OrderID" />
          <property name="Output List.[00].Table" value="o" />
          <property name="Output List.[00].Column" value="OrderID" />
          <property name="Output List.[00].DataType" value="Int32" />
          <property name="Output List.[00].Output Name" value="OrderID" />
          <property name="Output List.[01]" value="o.CustomerID AS CustomerID" />
          <property name="Output List.[01].Table" value="o" />
          <property name="Output List.[01].Column" value="CustomerID" />
          <property name="Output List.[01].DataType" value="String" />
          <property name="Output List.[01].Output Name" value="CustomerID" />
          <property name="Output List.[02]" value="o.EmployeeID AS EmployeeID" />
          <property name="Output List.[02].Table" value="o" />
          <property name="Output List.[02].Column" value="EmployeeID" />
          <property name="Output List.[02].DataType" value="Int32" />
          <property name="Output List.[02].Output Name" value="EmployeeID" />
          <property name="Output List.[03]" value="o.OrderDate AS OrderDate" />
          <property name="Output List.[03].Table" value="o" />
          <property name="Output List.[03].Column" value="OrderDate" />
          <property name="Output List.[03].DataType" value="DateTime" />
          <property name="Output List.[03].Output Name" value="OrderDate" />
          <property name="Output List.[04]" value="o.RequiredDate AS RequiredDate" />
          <property name="Output List.[04].Table" value="o" />
          <property name="Output List.[04].Column" value="RequiredDate" />
          <property name="Output List.[04].DataType" value="DateTime" />
          <property name="Output List.[04].Output Name" value="RequiredDate" />
          <property name="Output List.[05]" value="o.ShippedDate AS ShippedDate" />
          <property name="Output List.[05].Table" value="o" />
          <property name="Output List.[05].Column" value="ShippedDate" />
          <property name="Output List.[05].DataType" value="DateTime" />
          <property name="Output List.[05].Output Name" value="ShippedDate" />
          <property name="Output List.[06]" value="o.ShipVia AS ShipVia" />
          <property name="Output List.[06].Table" value="o" />
          <property name="Output List.[06].Column" value="ShipVia" />
          <property name="Output List.[06].DataType" value="Int32" />
          <property name="Output List.[06].Output Name" value="ShipVia" />
          <property name="Output List.[07]" value="o.Freight AS Freight" />
          <property name="Output List.[07].Table" value="o" />
          <property name="Output List.[07].Column" value="Freight" />
          <property name="Output List.[07].DataType" value="Decimal" />
          <property name="Output List.[07].Output Name" value="Freight" />
          <property name="Output List.[08]" value="o.ShipName AS ShipName" />
          <property name="Output List.[08].Table" value="o" />
          <property name="Output List.[08].Column" value="ShipName" />
          <property name="Output List.[08].DataType" value="String" />
          <property name="Output List.[08].Output Name" value="ShipName" />
          <property name="Output List.[09]" value="o.ShipAddress AS ShipAddress" />
          <property name="Output List.[09].Table" value="o" />
          <property name="Output List.[09].Column" value="ShipAddress" />
          <property name="Output List.[09].DataType" value="String" />
          <property name="Output List.[09].Output Name" value="ShipAddress" />
          <property name="Output List.[10]" value="o.ShipCity AS ShipCity" />
          <property name="Output List.[10].Table" value="o" />
          <property name="Output List.[10].Column" value="ShipCity" />
          <property name="Output List.[10].DataType" value="String" />
          <property name="Output List.[10].Output Name" value="ShipCity" />
          <property name="Output List.[11]" value="o.ShipRegion AS ShipRegion" />
          <property name="Output List.[11].Table" value="o" />
          <property name="Output List.[11].Column" value="ShipRegion" />
          <property name="Output List.[11].DataType" value="String" />
          <property name="Output List.[11].Output Name" value="ShipRegion" />
          <property name="Output List.[12]" value="o.ShipPostalCode AS ShipPostalCode" />
          <property name="Output List.[12].Table" value="o" />
          <property name="Output List.[12].Column" value="ShipPostalCode" />
          <property name="Output List.[12].DataType" value="String" />
          <property name="Output List.[12].Output Name" value="ShipPostalCode" />
          <property name="Output List.[13]" value="o.ShipCountry AS ShipCountry" />
          <property name="Output List.[13].Table" value="o" />
          <property name="Output List.[13].Column" value="ShipCountry" />
          <property name="Output List.[13].DataType" value="String" />
          <property name="Output List.[13].Output Name" value="ShipCountry" />
          <property name="Output List.[14]" value="c.CustomerID AS CustomerID" />
          <property name="Output List.[14].Table" value="c" />
          <property name="Output List.[14].Column" value="CustomerID" />
          <property name="Output List.[14].DataType" value="String" />
          <property name="Output List.[14].Output Name" value="CustomerID" />
          <property name="Output List.[15]" value="c.CompanyName AS CompanyName" />
          <property name="Output List.[15].Table" value="c" />
          <property name="Output List.[15].Column" value="CompanyName" />
          <property name="Output List.[15].DataType" value="String" />
          <property name="Output List.[15].Output Name" value="CompanyName" />
          <property name="Output List.[16]" value="c.ContactName AS ContactName" />
          <property name="Output List.[16].Table" value="c" />
          <property name="Output List.[16].Column" value="ContactName" />
          <property name="Output List.[16].DataType" value="String" />
          <property name="Output List.[16].Output Name" value="ContactName" />
          <property name="Output List.[17]" value="c.ContactTitle AS ContactTitle" />
          <property name="Output List.[17].Table" value="c" />
          <property name="Output List.[17].Column" value="ContactTitle" />
          <property name="Output List.[17].DataType" value="String" />
          <property name="Output List.[17].Output Name" value="ContactTitle" />
          <property name="Output List.[18]" value="c.Address AS Address" />
          <property name="Output List.[18].Table" value="c" />
          <property name="Output List.[18].Column" value="Address" />
          <property name="Output List.[18].DataType" value="String" />
          <property name="Output List.[18].Output Name" value="Address" />
          <property name="Output List.[19]" value="c.City AS City" />
          <property name="Output List.[19].Table" value="c" />
          <property name="Output List.[19].Column" value="City" />
          <property name="Output List.[19].DataType" value="String" />
          <property name="Output List.[19].Output Name" value="City" />
          <property name="Output List.[20]" value="c.Region AS Region" />
          <property name="Output List.[20].Table" value="c" />
          <property name="Output List.[20].Column" value="Region" />
          <property name="Output List.[20].DataType" value="String" />
          <property name="Output List.[20].Output Name" value="Region" />
          <property name="Output List.[21]" value="c.PostalCode AS PostalCode" />
          <property name="Output List.[21].Table" value="c" />
          <property name="Output List.[21].Column" value="PostalCode" />
          <property name="Output List.[21].DataType" value="String" />
          <property name="Output List.[21].Output Name" value="PostalCode" />
          <property name="Output List.[22]" value="c.Country AS Country" />
          <property name="Output List.[22].Table" value="c" />
          <property name="Output List.[22].Column" value="Country" />
          <property name="Output List.[22].DataType" value="String" />
          <property name="Output List.[22].Output Name" value="Country" />
          <property name="Output List.[23]" value="c.Phone AS Phone" />
          <property name="Output List.[23].Table" value="c" />
          <property name="Output List.[23].Column" value="Phone" />
          <property name="Output List.[23].DataType" value="String" />
          <property name="Output List.[23].Output Name" value="Phone" />
          <property name="Output List.[24]" value="c.Fax AS Fax" />
          <property name="Output List.[24].Table" value="c" />
          <property name="Output List.[24].Column" value="Fax" />
          <property name="Output List.[24].DataType" value="String" />
          <property name="Output List.[24].Output Name" value="Fax" />
        </properties>
        <input>
          <element operator="NestedLoops">
            <properties>
              <property name="Output List.[00]" value="c.CustomerID" />
              <property name="Output List.[00].Table" value="c" />
              <property name="Output List.[00].Column" value="CustomerID" />
              <property name="Output List.[00].DataType" value="String" />
              <property name="Output List.[01]" value="c.CompanyName" />
              <property name="Output List.[01].Table" value="c" />
              <property name="Output List.[01].Column" value="CompanyName" />
              <property name="Output List.[01].DataType" value="String" />
              <property name="Output List.[02]" value="c.ContactName" />
              <property name="Output List.[02].Table" value="c" />
              <property name="Output List.[02].Column" value="ContactName" />
              <property name="Output List.[02].DataType" value="String" />
              <property name="Output List.[03]" value="c.ContactTitle" />
              <property name="Output List.[03].Table" value="c" />
              <property name="Output List.[03].Column" value="ContactTitle" />
              <property name="Output List.[03].DataType" value="String" />
              <property name="Output List.[04]" value="c.Address" />
              <property name="Output List.[04].Table" value="c" />
              <property name="Output List.[04].Column" value="Address" />
              <property name="Output List.[04].DataType" value="String" />
              <property name="Output List.[05]" value="c.City" />
              <property name="Output List.[05].Table" value="c" />
              <property name="Output List.[05].Column" value="City" />
              <property name="Output List.[05].DataType" value="String" />
              <property name="Output List.[06]" value="c.Region" />
              <property name="Output List.[06].Table" value="c" />
              <property name="Output List.[06].Column" value="Region" />
              <property name="Output List.[06].DataType" value="String" />
              <property name="Output List.[07]" value="c.PostalCode" />
              <property name="Output List.[07].Table" value="c" />
              <property name="Output List.[07].Column" value="PostalCode" />
              <property name="Output List.[07].DataType" value="String" />
              <property name="Output List.[08]" value="c.Country" />
              <property name="Output List.[08].Table" value="c" />
              <property name="Output List.[08].Column" value="Country" />
              <property name="Output List.[08].DataType" value="String" />
              <property name="Output List.[09]" value="c.Phone" />
              <property name="Output List.[09].Table" value="c" />
              <property name="Output List.[09].Column" value="Phone" />
              <property name="Output List.[09].DataType" value="String" />
              <property name="Output List.[10]" value="c.Fax" />
              <property name="Output List.[10].Table" value="c" />
              <property name="Output List.[10].Column" value="Fax" />
              <property name="Output List.[10].DataType" value="String" />
              <property name="Output List.[11]" value="o.OrderID" />
              <property name="Output List.[11].Table" value="o" />
              <property name="Output List.[11].Column" value="OrderID" />
              <property name="Output List.[11].DataType" value="Int32" />
              <property name="Output List.[12]" value="o.CustomerID" />
              <property name="Output List.[12].Table" value="o" />
              <property name="Output List.[12].Column" value="CustomerID" />
              <property name="Output List.[12].DataType" value="String" />
              <property name="Output List.[13]" value="o.EmployeeID" />
              <property name="Output List.[13].Table" value="o" />
              <property name="Output List.[13].Column" value="EmployeeID" />
              <property name="Output List.[13].DataType" value="Int32" />
              <property name="Output List.[14]" value="o.OrderDate" />
              <property name="Output List.[14].Table" value="o" />
              <property name="Output List.[14].Column" value="OrderDate" />
              <property name="Output List.[14].DataType" value="DateTime" />
              <property name="Output List.[15]" value="o.RequiredDate" />
              <property name="Output List.[15].Table" value="o" />
              <property name="Output List.[15].Column" value="RequiredDate" />
              <property name="Output List.[15].DataType" value="DateTime" />
              <property name="Output List.[16]" value="o.ShippedDate" />
              <property name="Output List.[16].Table" value="o" />
              <property name="Output List.[16].Column" value="ShippedDate" />
              <property name="Output List.[16].DataType" value="DateTime" />
              <property name="Output List.[17]" value="o.ShipVia" />
              <property name="Output List.[17].Table" value="o" />
              <property name="Output List.[17].Column" value="ShipVia" />
              <property name="Output List.[17].DataType" value="Int32" />
              <property name="Output List.[18]" value="o.Freight" />
              <property name="Output List.[18].Table" value="o" />
              <property name="Output List.[18].Column" value="Freight" />
              <property name="Output List.[18].DataType" value="Decimal" />
              <property name="Output List.[19]" value="o.ShipName" />
              <property name="Output List.[19].Table" value="o" />
              <property name="Output List.[19].Column" value="ShipName" />
              <property name="Output List.[19].DataType" value="String" />
              <property name="Output List.[20]" value="o.ShipAddress" />
              <property name="Output List.[20].Table" value="o" />
              <property name="Output List.[20].Column" value="ShipAddress" />
              <property name="Output List.[20].DataType" value="String" />
              <property name="Output List.[21]" value="o.ShipCity" />
              <property name="Output List.[21].Table" value="o" />
              <property name="Output List.[21].Column" value="ShipCity" />
              <property name="Output List.[21].DataType" value="String" />
              <property name="Output List.[22]" value="o.ShipRegion" />
              <property name="Output List.[22].Table" value="o" />
              <property name="Output List.[22].Column" value="ShipRegion" />
              <property name="Output List.[22].DataType" value="String" />
              <property name="Output List.[23]" value="o.ShipPostalCode" />
              <property name="Output List.[23].Table" value="o" />
              <property name="Output List.[23].Column" value="ShipPostalCode" />
              <property name="Output List.[23].DataType" value="String" />
              <property name="Output List.[24]" value="o.ShipCountry" />
              <property name="Output List.[24].Table" value="o" />
              <property name="Output List.[24].Column" value="ShipCountry" />
              <property name="Output List.[24].DataType" value="String" />
              <property name="Logical Operator" value="Inner Join" />
              <property name="Statistics.Open Count" value="1" />
              <property name="Statistics.Row Count" value="17" />
              <property name="Statistics.Average Row Count" value="17" />
              <property name="Predicate" value="Expr1028 = c.City" />
              <property name="Outer References.[0]" value="o.EmployeeID" />
              <property name="Outer References.[0].Table" value="o" />
              <property name="Outer References.[0].Column" value="EmployeeID" />
              <property name="Outer References.[0].DataType" value="Int32" />
            </properties>
            <input>
              <element operator="HashMatch">
                <properties>
                  <property name="Output List.[00]" value="c.CustomerID" />
                  <property name="Output List.[00].Table" value="c" />
                  <property name="Output List.[00].Column" value="CustomerID" />
                  <property name="Output List.[00].DataType" value="String" />
                  <property name="Output List.[01]" value="c.CompanyName" />
                  <property name="Output List.[01].Table" value="c" />
                  <property name="Output List.[01].Column" value="CompanyName" />
                  <property name="Output List.[01].DataType" value="String" />
                  <property name="Output List.[02]" value="c.ContactName" />
                  <property name="Output List.[02].Table" value="c" />
                  <property name="Output List.[02].Column" value="ContactName" />
                  <property name="Output List.[02].DataType" value="String" />
                  <property name="Output List.[03]" value="c.ContactTitle" />
                  <property name="Output List.[03].Table" value="c" />
                  <property name="Output List.[03].Column" value="ContactTitle" />
                  <property name="Output List.[03].DataType" value="String" />
                  <property name="Output List.[04]" value="c.Address" />
                  <property name="Output List.[04].Table" value="c" />
                  <property name="Output List.[04].Column" value="Address" />
                  <property name="Output List.[04].DataType" value="String" />
                  <property name="Output List.[05]" value="c.City" />
                  <property name="Output List.[05].Table" value="c" />
                  <property name="Output List.[05].Column" value="City" />
                  <property name="Output List.[05].DataType" value="String" />
                  <property name="Output List.[06]" value="c.Region" />
                  <property name="Output List.[06].Table" value="c" />
                  <property name="Output List.[06].Column" value="Region" />
                  <property name="Output List.[06].DataType" value="String" />
                  <property name="Output List.[07]" value="c.PostalCode" />
                  <property name="Output List.[07].Table" value="c" />
                  <property name="Output List.[07].Column" value="PostalCode" />
                  <property name="Output List.[07].DataType" value="String" />
                  <property name="Output List.[08]" value="c.Country" />
                  <property name="Output List.[08].Table" value="c" />
                  <property name="Output List.[08].Column" value="Country" />
                  <property name="Output List.[08].DataType" value="String" />
                  <property name="Output List.[09]" value="c.Phone" />
                  <property name="Output List.[09].Table" value="c" />
                  <property name="Output List.[09].Column" value="Phone" />
                  <property name="Output List.[09].DataType" value="String" />
                  <property name="Output List.[10]" value="c.Fax" />
                  <property name="Output List.[10].Table" value="c" />
                  <property name="Output List.[10].Column" value="Fax" />
                  <property name="Output List.[10].DataType" value="String" />
                  <property name="Output List.[11]" value="o.OrderID" />
                  <property name="Output List.[11].Table" value="o" />
                  <property name="Output List.[11].Column" value="OrderID" />
                  <property name="Output List.[11].DataType" value="Int32" />
                  <property name="Output List.[12]" value="o.CustomerID" />
                  <property name="Output List.[12].Table" value="o" />
                  <property name="Output List.[12].Column" value="CustomerID" />
                  <property name="Output List.[12].DataType" value="String" />
                  <property name="Output List.[13]" value="o.EmployeeID" />
                  <property name="Output List.[13].Table" value="o" />
                  <property name="Output List.[13].Column" value="EmployeeID" />
                  <property name="Output List.[13].DataType" value="Int32" />
                  <property name="Output List.[14]" value="o.OrderDate" />
                  <property name="Output List.[14].Table" value="o" />
                  <property name="Output List.[14].Column" value="OrderDate" />
                  <property name="Output List.[14].DataType" value="DateTime" />
                  <property name="Output List.[15]" value="o.RequiredDate" />
                  <property name="Output List.[15].Table" value="o" />
                  <property name="Output List.[15].Column" value="RequiredDate" />
                  <property name="Output List.[15].DataType" value="DateTime" />
                  <property name="Output List.[16]" value="o.ShippedDate" />
                  <property name="Output List.[16].Table" value="o" />
                  <property name="Output List.[16].Column" value="ShippedDate" />
                  <property name="Output List.[16].DataType" value="DateTime" />
                  <property name="Output List.[17]" value="o.ShipVia" />
                  <property name="Output List.[17].Table" value="o" />
                  <property name="Output List.[17].Column" value="ShipVia" />
                  <property name="Output List.[17].DataType" value="Int32" />
                  <property name="Output List.[18]" value="o.Freight" />
                  <property name="Output List.[18].Table" value="o" />
                  <property name="Output List.[18].Column" value="Freight" />
                  <property name="Output List.[18].DataType" value="Decimal" />
                  <property name="Output List.[19]" value="o.ShipName" />
                  <property name="Output List.[19].Table" value="o" />
                  <property name="Output List.[19].Column" value="ShipName" />
                  <property name="Output List.[19].DataType" value="String" />
                  <property name="Output List.[20]" value="o.ShipAddress" />
                  <property name="Output List.[20].Table" value="o" />
                  <property name="Output List.[20].Column" value="ShipAddress" />
                  <property name="Output List.[20].DataType" value="String" />
                  <property name="Output List.[21]" value="o.ShipCity" />
                  <property name="Output List.[21].Table" value="o" />
                  <property name="Output List.[21].Column" value="ShipCity" />
                  <property name="Output List.[21].DataType" value="String" />
                  <property name="Output List.[22]" value="o.ShipRegion" />
                  <property name="Output List.[22].Table" value="o" />
                  <property name="Output List.[22].Column" value="ShipRegion" />
                  <property name="Output List.[22].DataType" value="String" />
                  <property name="Output List.[23]" value="o.ShipPostalCode" />
                  <property name="Output List.[23].Table" value="o" />
                  <property name="Output List.[23].Column" value="ShipPostalCode" />
                  <property name="Output List.[23].DataType" value="String" />
                  <property name="Output List.[24]" value="o.ShipCountry" />
                  <property name="Output List.[24].Table" value="o" />
                  <property name="Output List.[24].Column" value="ShipCountry" />
                  <property name="Output List.[24].DataType" value="String" />
                  <property name="Statistics.Open Count" value="1" />
                  <property name="Statistics.Row Count" value="830" />
                  <property name="Statistics.Average Row Count" value="830" />
                  <property name="Hash Keys Build" value="c.CustomerID" />
                  <property name="Hash Keys Build.Table" value="c" />
                  <property name="Hash Keys Build.Column" value="CustomerID" />
                  <property name="Hash Keys Build.DataType" value="String" />
                  <property name="Hash Keys Probe" value="o.CustomerID" />
                  <property name="Hash Keys Probe.Table" value="o" />
                  <property name="Hash Keys Probe.Column" value="CustomerID" />
                  <property name="Hash Keys Probe.DataType" value="String" />
                  <property name="Logical Operator" value="Inner Join" />
                </properties>
                <input>
                  <element operator="TableScan">
                    <properties>
                      <property name="Table" value="Customers AS c" />
                      <property name="Output List.[00]" value="c.CustomerID" />
                      <property name="Output List.[00].Table" value="c" />
                      <property name="Output List.[00].Column" value="CustomerID" />
                      <property name="Output List.[00].DataType" value="String" />
                      <property name="Output List.[01]" value="c.CompanyName" />
                      <property name="Output List.[01].Table" value="c" />
                      <property name="Output List.[01].Column" value="CompanyName" />
                      <property name="Output List.[01].DataType" value="String" />
                      <property name="Output List.[02]" value="c.ContactName" />
                      <property name="Output List.[02].Table" value="c" />
                      <property name="Output List.[02].Column" value="ContactName" />
                      <property name="Output List.[02].DataType" value="String" />
                      <property name="Output List.[03]" value="c.ContactTitle" />
                      <property name="Output List.[03].Table" value="c" />
                      <property name="Output List.[03].Column" value="ContactTitle" />
                      <property name="Output List.[03].DataType" value="String" />
                      <property name="Output List.[04]" value="c.Address" />
                      <property name="Output List.[04].Table" value="c" />
                      <property name="Output List.[04].Column" value="Address" />
                      <property name="Output List.[04].DataType" value="String" />
                      <property name="Output List.[05]" value="c.City" />
                      <property name="Output List.[05].Table" value="c" />
                      <property name="Output List.[05].Column" value="City" />
                      <property name="Output List.[05].DataType" value="String" />
                      <property name="Output List.[06]" value="c.Region" />
                      <property name="Output List.[06].Table" value="c" />
                      <property name="Output List.[06].Column" value="Region" />
                      <property name="Output List.[06].DataType" value="String" />
                      <property name="Output List.[07]" value="c.PostalCode" />
                      <property name="Output List.[07].Table" value="c" />
                      <property name="Output List.[07].Column" value="PostalCode" />
                      <property name="Output List.[07].DataType" value="String" />
                      <property name="Output List.[08]" value="c.Country" />
                      <property name="Output List.[08].Table" value="c" />
                      <property name="Output List.[08].Column" value="Country" />
                      <property name="Output List.[08].DataType" value="String" />
                      <property name="Output List.[09]" value="c.Phone" />
                      <property name="Output List.[09].Table" value="c" />
                      <property name="Output List.[09].Column" value="Phone" />
                      <property name="Output List.[09].DataType" value="String" />
                      <property name="Output List.[10]" value="c.Fax" />
                      <property name="Output List.[10].Table" value="c" />
                      <property name="Output List.[10].Column" value="Fax" />
                      <property name="Output List.[10].DataType" value="String" />
                      <property name="Statistics.Open Count" value="1" />
                      <property name="Statistics.Row Count" value="91" />
                      <property name="Statistics.Average Row Count" value="91" />
                    </properties>
                    <input />
                  </element>
                  <element operator="TableScan">
                    <properties>
                      <property name="Table" value="Orders AS o" />
                      <property name="Output List.[00]" value="o.OrderID" />
                      <property name="Output List.[00].Table" value="o" />
                      <property name="Output List.[00].Column" value="OrderID" />
                      <property name="Output List.[00].DataType" value="Int32" />
                      <property name="Output List.[01]" value="o.CustomerID" />
                      <property name="Output List.[01].Table" value="o" />
                      <property name="Output List.[01].Column" value="CustomerID" />
                      <property name="Output List.[01].DataType" value="String" />
                      <property name="Output List.[02]" value="o.EmployeeID" />
                      <property name="Output List.[02].Table" value="o" />
                      <property name="Output List.[02].Column" value="EmployeeID" />
                      <property name="Output List.[02].DataType" value="Int32" />
                      <property name="Output List.[03]" value="o.OrderDate" />
                      <property name="Output List.[03].Table" value="o" />
                      <property name="Output List.[03].Column" value="OrderDate" />
                      <property name="Output List.[03].DataType" value="DateTime" />
                      <property name="Output List.[04]" value="o.RequiredDate" />
                      <property name="Output List.[04].Table" value="o" />
                      <property name="Output List.[04].Column" value="RequiredDate" />
                      <property name="Output List.[04].DataType" value="DateTime" />
                      <property name="Output List.[05]" value="o.ShippedDate" />
                      <property name="Output List.[05].Table" value="o" />
                      <property name="Output List.[05].Column" value="ShippedDate" />
                      <property name="Output List.[05].DataType" value="DateTime" />
                      <property name="Output List.[06]" value="o.ShipVia" />
                      <property name="Output List.[06].Table" value="o" />
                      <property name="Output List.[06].Column" value="ShipVia" />
                      <property name="Output List.[06].DataType" value="Int32" />
                      <property name="Output List.[07]" value="o.Freight" />
                      <property name="Output List.[07].Table" value="o" />
                      <property name="Output List.[07].Column" value="Freight" />
                      <property name="Output List.[07].DataType" value="Decimal" />
                      <property name="Output List.[08]" value="o.ShipName" />
                      <property name="Output List.[08].Table" value="o" />
                      <property name="Output List.[08].Column" value="ShipName" />
                      <property name="Output List.[08].DataType" value="String" />
                      <property name="Output List.[09]" value="o.ShipAddress" />
                      <property name="Output List.[09].Table" value="o" />
                      <property name="Output List.[09].Column" value="ShipAddress" />
                      <property name="Output List.[09].DataType" value="String" />
                      <property name="Output List.[10]" value="o.ShipCity" />
                      <property name="Output List.[10].Table" value="o" />
                      <property name="Output List.[10].Column" value="ShipCity" />
                      <property name="Output List.[10].DataType" value="String" />
                      <property name="Output List.[11]" value="o.ShipRegion" />
                      <property name="Output List.[11].Table" value="o" />
                      <property name="Output List.[11].Column" value="ShipRegion" />
                      <property name="Output List.[11].DataType" value="String" />
                      <property name="Output List.[12]" value="o.ShipPostalCode" />
                      <property name="Output List.[12].Table" value="o" />
                      <property name="Output List.[12].Column" value="ShipPostalCode" />
                      <property name="Output List.[12].DataType" value="String" />
                      <property name="Output List.[13]" value="o.ShipCountry" />
                      <property name="Output List.[13].Table" value="o" />
                      <property name="Output List.[13].Column" value="ShipCountry" />
                      <property name="Output List.[13].DataType" value="String" />
                      <property name="Statistics.Open Count" value="1" />
                      <property name="Statistics.Row Count" value="830" />
                      <property name="Statistics.Average Row Count" value="830" />
                    </properties>
                    <input />
                  </element>
                </input>
              </element>
              <element operator="Assert">
                <properties>
                  <property name="Output List.[0]" value="Expr1028" />
                  <property name="Output List.[0].Column" value="Expr1028" />
                  <property name="Output List.[0].DataType" value="String" />
                  <property name="Statistics.Open Count" value="830" />
                  <property name="Statistics.Row Count" value="830" />
                  <property name="Statistics.Average Row Count" value="1" />
                  <property name="Predicate" value="CASE WHEN Expr1027 &gt; 1 THEN 0 END" />
                </properties>
                <input>
                  <element operator="StreamAggregate">
                    <properties>
                      <property name="Output List.[0]" value="Expr1027" />
                      <property name="Output List.[0].Column" value="Expr1027" />
                      <property name="Output List.[0].DataType" value="Int32" />
                      <property name="Output List.[1]" value="Expr1028" />
                      <property name="Output List.[1].Column" value="Expr1028" />
                      <property name="Output List.[1].DataType" value="String" />
                      <property name="Statistics.Open Count" value="830" />
                      <property name="Statistics.Row Count" value="830" />
                      <property name="Statistics.Average Row Count" value="1" />
                      <property name="Defined Values.[0]" value="Expr1027 = COUNT(0)" />
                      <property name="Defined Values.[0].Target" value="Expr1027" />
                      <property name="Defined Values.[0].DataType" value="Int32" />
                      <property name="Defined Values.[0].Source" value="COUNT(0)" />
                      <property name="Defined Values.[1]" value="Expr1028 = ANY(e.City)" />
                      <property name="Defined Values.[1].Target" value="Expr1028" />
                      <property name="Defined Values.[1].DataType" value="String" />
                      <property name="Defined Values.[1].Source" value="ANY(e.City)" />
                    </properties>
                    <input>
                      <element operator="IndexSpool">
                        <properties>
                          <property name="Output List.[0]" value="e.City" />
                          <property name="Output List.[0].Table" value="e" />
                          <property name="Output List.[0].Column" value="City" />
                          <property name="Output List.[0].DataType" value="String" />
                          <property name="Statistics.Open Count" value="830" />
                          <property name="Statistics.Row Count" value="830" />
                          <property name="Statistics.Average Row Count" value="1" />
                          <property name="Logical Operator" value="Eager Spool" />
                          <property name="With Stack" value="False" />
                          <property name="Index" value="e.EmployeeID" />
                          <property name="Index.Table" value="e" />
                          <property name="Index.Column" value="EmployeeID" />
                          <property name="Index.DataType" value="Int32" />
                          <property name="Probe" value="o.EmployeeID" />
                        </properties>
                        <input>
                          <element operator="TableScan">
                            <properties>
                              <property name="Table" value="Employees AS e" />
                              <property name="Output List.[0]" value="e.EmployeeID" />
                              <property name="Output List.[0].Table" value="e" />
                              <property name="Output List.[0].Column" value="EmployeeID" />
                              <property name="Output List.[0].DataType" value="Int32" />
                              <property name="Output List.[1]" value="e.City" />
                              <property name="Output List.[1].Table" value="e" />
                              <property name="Output List.[1].Column" value="City" />
                              <property name="Output List.[1].DataType" value="String" />
                              <property name="Statistics.Open Count" value="1" />
                              <property name="Statistics.Row Count" value="9" />
                              <property name="Statistics.Average Row Count" value="9" />
                            </properties>
                            <input />
                          </element>
                        </input>
                      </element>
                    </input>
                  </element>
                </input>
              </element>
            </input>
          </element>
        </input>
      </element>
    </executionPlan>
  </expectedPlan>
</test>